package com.ysd.crm.model;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EntityListeners;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;

import org.springframework.data.annotation.CreatedDate;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;
import org.springframework.format.annotation.DateTimeFormat;

import lombok.Data;
@Table
@Data
@Entity
@EntityListeners(AuditingEntityListener.class)
public class Student {
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id; //学生编号
	@NotNull
	private String name; //学员姓名
	private int age; //年龄
	private String sex; //性别
	private String phone; //学员电话
	private String StuStatus; //学历
	private String PerState; //个人状态
	private String MsgSource; //来源渠道
	private String SourceUrl; //来源网址
	private String SourceKeyWord; //来源关键词
	private String Address; //所在区域
	private String NetPusherId; //网络咨询id
	private String AskerId; //咨询师ID
	private String QQ; //学院qq
	private String WeiXin; //学院微信
	private String Content; //备注
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @CreatedDate
	private Date CreateTime; //创建时间
	private String LearnForward; //课程方向
	@Column(name="IsValid",columnDefinition = "varchar(255) default '否'")
	private String IsValid; //是否有效
	private String Record; //打分
	@Column(name = "IsReturnVist",columnDefinition = "varchar(255) default '否'")
	private String IsReturnVist; //是否回访
	private Date FirstVisitTime; //首次回访时间
	@Column(name = "IsHome",columnDefinition = "varchar(255) default '否'")
	private String IsHome; //是否上门
	private Date HomeTime; //上门时间
	private String LostValid; //无效原因
	@Column(name = "IsPay",columnDefinition = "varchar(255) default '否'")
	private String IsPay; //是否付款
	private Date PayTime; //付款时间
	@Column(name = "Money",columnDefinition = "double(10,2) default 0.00")
	private double Money; //付款金额
	@Column(name = "IsReturnMoney",columnDefinition = "varchar(255) default '否'")
	private String IsReturnMoney; //是否退费
	@Column(name = "IsInClass",columnDefinition = "varchar(255) default '否'")
	private String IsInClass; //是否进班
	private Date InClassTime; //进班时间
	private String InClassContent; //进班备注
	private String AskerContent; //咨询师备注
	@Column(name = "IsDel",columnDefinition = "varchar(255) default '否'")
	private String IsDel; //是否删除
	private String FromPart; //来源部门
	private String StuConcern; //学员关注
	private String IsBaoBei; //是否报备
	private String ZiXunName; //咨询师填写的姓名
	private String CreateUser; //录入人姓名
	private String ReturnMoneyReason; //退费原因
	@Column(name = "PreMoney",columnDefinition = "double(10,2) default 0.00")
	private double PreMoney; //预付定金
	private Date PreMoneyTime; //预付定金时间
	
	
	
}
